package org.jeecg.modules.zonglzp.mapper;


import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.zonglzp.entity.Customer;
import org.jeecg.modules.zonglzp.entity.ExcelEntity;
import org.springframework.stereotype.Component;

import java.util.Date;
import java.util.List;

@Component
public interface CustomerMapper {

    //查询我的客户列表
    IPage<Customer> getCustomerlist(Page<Customer> page, @Param("userid") String userid, @Param("customerCode") String customerCode, @Param("customerName") String customerName);

    //根据员工编号查询员工
    Customer getyuangongbycode(@Param("customerCode") String customerCode);


    //查询未量体员工
    IPage<Customer> getweiliangtiyuangong(Page<Customer> page, String departId);


    //设置花名册
    void sethmc(Customer title, @Param("departId2") String departId, @Param("date") Date date);


    //先把老的花名册全部删了
    void deletedeparthmc(@Param("departId2") String departId2);

    //查询标题
    List<Customer> gettitles(@Param("departId") String departId);


    //查询花名册
    IPage<Customer> gethmclist(Page<Customer> page, @Param("departId") String departId);


    //删除花名册中的员工
    int deleteCustomer(@Param("id") int id);


    //编辑花名册中的员工
    int updateCustomer(Customer customer);

    //设置花名册中 下班模板 模板中的数据
    List<ExcelEntity> getmobandata();


    void importhmc(ExcelEntity excelEntity);

    //清空部门
    int cleardepart(@Param("departId") String departId);

    //通过这个编号查询之前这个人编号的人是否已经存在
    String getcustomercodebycode(@Param("customerCode") String customerCode,@Param("parentId")  int parentId);

    int getsexNumber(@Param("departId") String departId,@Param("i") int i);
}
